<?php
session_start();

require_once($_SERVER['DOCUMENT_ROOT'].'/mpd/config/config.php');
$id = $_SESSION['ID_DEPARTEMEN'];




$query=mysql_query("SELECT b.NIP as NIP, b.NAMA as NAMA, b.TANGGAL_MASUK as TANGGAL_MASUK, b.TANGGAL_TETAP as TANGGAL_TETAP, d.NAMA_DEPARTEMEN as DEPARTEMEN, s.NAMA_STATUS as STATUS 
					FROM biodata as b, status as s, departemen as d where s.ID_STATUS = b.ID_STATUS and b.ID_DEPARTEMEN = d.ID_DEPARTEMEN and (ID_ROLE = 3 or ID_ROLE = 4) and b.ID_DEPARTEMEN =".$id);


?>